home *** CD-ROM | disk | FTP | other *** search
/ Suzy B Software 2 / Suzy B Software CD-ROM 2 (1994).iso / finances / sheet30d / samples.arc / SAMPLE16.ARC / BESTFIT.SHT < prev    next >
Unknown  |  1988-10-10  |  2.9 KB
open in: MacOS 8.1     |     Win98     |     DOS

view JSON data     |     view as text


This file was not able to be converted.
This format is not currently supported by dexvert.

ConfidenceProgramDetectionMatch TypeSupport
1% dexvert OrCAD Schematic (document/orCADSchematic) ext Unsupported
1% dexvert DTV Shot (other/dtvShot) ext Unsupported
1% dexvert Links LS Data (other/linksLSData) ext Unsupported
100% file data default
100% TrID Sybase iAnywhere database files default (weak)


hex view
+--------+-------------------------+-------------------------+--------+--------+
|00000000| 31 33 01 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |13......|........|
|00000010| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000030| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000040| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000050| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000060| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000070| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000080| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000090| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000100| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 20 42 |........|...... B|
|00000110| 65 73 74 20 4c 65 61 73 | 74 2d 73 71 75 61 72 65 |est Leas|t-square|
|00000120| 73 20 46 69 74 20 00 00 | 00 00 00 00 00 00 00 00 |s Fit ..|........|
|00000130| 00 00 00 00 00 00 08 5b | 09 04 09 01 09 09 09 09 |.......[|........|
|00000140| 09 09 09 09 09 09 09 09 | 09 09 09 09 09 09 09 09 |........|........|
|00000150| 09 09 09 09 09 09 09 09 | 09 09 09 09 09 09 09 09 |........|........|
|00000160| 09 09 09 09 09 09 09 09 | 09 09 09 09 09 09 09 09 |........|........|
|00000170| 09 09 09 09 09 09 09 09 | 09 09 09 09 09 09 09 09 |........|........|
|00000180| 09 09 09 09 09 09 09 09 | 09 09 09 09 09 09 09 09 |........|........|
|00000190| 09 09 09 09 09 09 09 09 | 09 09 09 09 09 09 09 09 |........|........|
|000001a0| 09 09 09 09 09 09 09 09 | 09 09 09 09 09 09 09 09 |........|........|
|000001b0| 09 09 09 09 09 09 09 09 | 09 09 09 09 09 09 09 09 |........|........|
|000001c0| 09 09 09 09 09 09 09 09 | 09 09 09 09 09 09 09 09 |........|........|
|000001d0| 09 09 09 09 09 09 09 09 | 09 09 09 09 09 09 09 09 |........|........|
|000001e0| 09 09 09 09 09 09 09 09 | 09 09 09 09 09 09 09 09 |........|........|
|000001f0| 09 09 09 09 09 09 09 09 | 09 09 09 09 09 09 09 09 |........|........|
|00000200| 09 09 09 09 09 09 09 09 | 09 09 09 09 09 09 09 09 |........|........|
|00000210| 09 09 09 09 09 09 09 09 | 09 09 09 09 09 09 09 09 |........|........|
|00000220| 09 09 09 09 09 09 09 09 | 09 09 09 09 09 09 09 09 |........|........|
|00000230| 09 09 09 09 09 09 09 09 | 00 11 00 00 00 0b 02 80 |........|........|
|00000240| 00 bd 00 01 00 01 00 01 | 00 01 00 03 00 01 00 01 |........|........|
|00000250| 00 08 00 00 00 46 00 00 | 00 02 c7 1e 00 04 27 54 |.....F..|......'T|
|00000260| 68 69 73 20 73 70 72 65 | 61 64 73 68 65 65 74 20 |his spre|adsheet |
|00000270| 75 73 65 73 20 4d 41 54 | 52 49 58 20 66 75 6e 63 |uses MAT|RIX func|
|00000280| 74 69 6f 6e 73 20 74 6f | 20 66 69 6e 64 20 74 68 |tions to| find th|
|00000290| 65 20 62 65 73 74 20 6c | 65 61 73 74 2d 73 71 75 |e best l|east-squ|
|000002a0| 61 72 65 73 00 02 00 01 | 00 08 00 00 00 26 00 00 |ares....|.....&..|
|000002b0| 00 02 c7 1e 00 04 27 66 | 69 74 20 74 6f 20 74 68 |......'f|it to th|
|000002c0| 65 20 70 6f 6c 79 6e 6f | 6d 69 61 6c 20 20 20 79 |e polyno|mial   y|
|000002d0| 3d 61 2b 62 2a 78 2b 63 | 2a 78 5e 32 00 03 00 01 |=a+b*x+c|*x^2....|
|000002e0| 00 08 00 00 00 2a 00 00 | 00 02 6d 20 00 01 27 77 |.....*..|..m ..'w|
|000002f0| 68 65 72 65 20 74 68 65 | 20 78 20 61 6e 64 20 79 |here the| x and y|
|00000300| 20 76 61 6c 75 65 73 20 | 61 72 65 20 67 69 76 65 | values |are give|
|00000310| 6e 20 62 65 6c 6f 77 2e | 00 05 00 02 00 08 00 00 |n below.|........|
|00000320| 00 02 00 00 00 02 6d 20 | 00 01 5e 78 00 05 00 03 |......m |..^x....|
|00000330| 00 08 00 00 00 02 00 00 | 00 02 6d 20 00 01 27 7c |........|..m ..'||
|00000340| 00 05 00 04 00 08 00 00 | 00 02 00 00 00 02 6d 20 |........|......m |
|00000350| 00 01 5e 79 00 06 00 02 | 00 08 00 00 00 02 00 00 |..^y....|........|
|00000360| 00 02 6d 20 00 01 5c 2d | 00 06 00 03 00 08 00 00 |..m ..\-|........|
|00000370| 00 02 00 00 00 02 6d 20 | 00 01 27 7c 00 06 00 04 |......m |..'|....|
|00000380| 00 08 00 00 00 02 00 00 | 00 02 6d 20 00 01 5c 2d |........|..m ..\-|
|00000390| 00 06 00 06 00 08 00 00 | 00 03 00 00 00 02 6d 20 |........|......m |
|000003a0| 00 01 27 4d 3a 00 07 00 | 02 00 81 00 02 00 09 40 |..'M:...|.......@|
|000003b0| 00 00 00 00 00 00 00 95 | 40 00 00 00 00 00 00 00 |........|@.......|
|000003c0| 00 07 00 03 00 08 00 00 | 00 02 00 00 00 02 6d 20 |........|......m |
|000003d0| 00 01 27 7c 00 07 00 04 | 00 81 00 02 00 09 40 da |..'|....|......@.|
|000003e0| e1 47 ae 14 7a e1 95 40 | da e1 47 ae 14 7a e1 00 |.G..z..@|..G..z..|
|000003f0| 07 00 06 00 81 00 02 00 | 09 40 80 00 00 00 00 00 |........|.@......|
|00000400| 00 95 40 80 00 00 00 00 | 00 00 00 07 00 07 00 82 |..@.....|........|
|00000410| 00 02 00 06 40 00 00 00 | 00 00 00 00 90 94 00 07 |....@...|........|
|00000420| 00 02 00 07 00 08 00 82 | 00 02 00 0c 3f 80 00 00 |........|....?...|
|00000430| 00 00 00 00 90 94 00 07 | 00 02 8e 94 00 07 00 02 |........|........|
|00000440| 00 08 00 02 00 81 00 02 | 00 09 40 80 00 00 00 00 |........|..@.....|
|00000450| 00 00 95 40 80 00 00 00 | 00 00 00 00 08 00 03 00 |...@....|........|
|00000460| 08 00 00 00 02 00 00 00 | 02 6d 20 00 01 27 7c 00 |........|.m ..'|.|
|00000470| 08 00 04 00 81 00 02 00 | 09 41 1c cc cc cc cc cc |........|.A......|
|00000480| cd 95 41 1c cc cc cc cc | cc cd 00 08 00 06 00 81 |..A.....|........|
|00000490| 00 02 00 09 40 80 00 00 | 00 00 00 00 95 40 80 00 |....@...|.....@..|
|000004a0| 00 00 00 00 00 00 08 00 | 07 00 82 00 02 00 06 40 |........|.......@|
|000004b0| 80 00 00 00 00 00 00 90 | 94 00 08 00 02 00 08 00 |........|........|
|000004c0| 08 00 82 00 02 00 0c 40 | 80 00 00 00 00 00 00 90 |.......@|........|
|000004d0| 94 00 08 00 02 8e 94 00 | 08 00 02 00 09 00 02 00 |........|........|
|000004e0| 81 00 02 00 09 40 c0 00 | 00 00 00 00 00 95 40 c0 |.....@..|......@.|
|000004f0| 00 00 00 00 00 00 00 09 | 00 03 00 08 00 00 00 02 |........|........|
|00000500| 00 00 00 02 6d 20 00 01 | 27 7c 00 09 00 04 00 81 |....m ..|'|......|
|00000510| 00 02 00 09 41 73 d7 0a | 3d 70 a3 d7 95 41 73 d7 |....As..|=p...As.|
|00000520| 0a 3d 70 a3 d7 00 09 00 | 06 00 81 00 02 00 09 40 |.=p.....|.......@|
|00000530| 80 00 00 00 00 00 00 95 | 40 80 00 00 00 00 00 00 |........|@.......|
|00000540| 00 09 00 07 00 82 00 02 | 00 06 40 c0 00 00 00 00 |........|..@.....|
|00000550| 00 00 90 94 00 09 00 02 | 00 09 00 08 00 82 00 02 |........|........|
|00000560| 00 0c 41 10 00 00 00 00 | 00 00 90 94 00 09 00 02 |..A.....|........|
|00000570| 8e 94 00 09 00 02 00 0a | 00 02 00 81 00 02 00 09 |........|........|
|00000580| 41 00 00 00 00 00 00 00 | 95 41 00 00 00 00 00 00 |A.......|.A......|
|00000590| 00 00 0a 00 03 00 08 00 | 00 00 02 00 00 00 02 6d |........|.......m|
|000005a0| 20 00 01 27 7c 00 0a 00 | 04 00 81 00 02 00 09 41 | ..'|...|.......A|
|000005b0| 99 99 99 99 99 99 9a 95 | 41 99 99 99 99 99 99 9a |........|A.......|
|000005c0| 00 0a 00 06 00 81 00 02 | 00 09 40 80 00 00 00 00 |........|..@.....|
|000005d0| 00 00 95 40 80 00 00 00 | 00 00 00 00 0a 00 07 00 |...@....|........|
|000005e0| 82 00 02 00 06 41 00 00 | 00 00 00 00 00 90 94 00 |.....A..|........|
|000005f0| 0a 00 02 00 0a 00 08 00 | 82 00 02 00 0c 41 80 00 |........|.....A..|
|00000600| 00 00 00 00 00 90 94 00 | 0a 00 02 8e 94 00 0a 00 |........|........|
|00000610| 02 00 0b 00 02 00 81 00 | 02 00 09 41 20 00 00 00 |........|...A ...|
|00000620| 00 00 00 95 41 20 00 00 | 00 00 00 00 00 0b 00 03 |....A ..|........|
|00000630| 00 08 00 00 00 02 00 00 | 00 02 6d 20 00 01 27 7c |........|..m ..'||
|00000640| 00 0b 00 04 00 81 00 02 | 00 09 41 e3 33 33 33 33 |........|..A.3333|
|00000650| 33 33 95 41 e3 33 33 33 | 33 33 33 00 0b 00 06 00 |33.A.333|333.....|
|00000660| 81 00 02 00 09 40 80 00 | 00 00 00 00 00 95 40 80 |.....@..|......@.|
|00000670| 00 00 00 00 00 00 00 0b | 00 07 00 82 00 02 00 06 |........|........|
|00000680| 41 20 00 00 00 00 00 00 | 90 94 00 0b 00 02 00 0b |A ......|........|
|00000690| 00 08 00 82 00 02 00 0c | 41 c8 00 00 00 00 00 00 |........|A.......|
|000006a0| 90 94 00 0b 00 02 8e 94 | 00 0b 00 02 00 0c 00 02 |........|........|
|000006b0| 00 81 00 02 00 09 41 40 | 00 00 00 00 00 00 95 41 |......A@|.......A|
|000006c0| 40 00 00 00 00 00 00 00 | 0c 00 03 00 08 00 00 00 |@.......|........|
|000006d0| 02 00 00 00 02 6d 20 00 | 01 27 7c 00 0c 00 04 00 |.....m .|.'|.....|
|000006e0| 81 00 02 00 09 42 09 99 | 99 99 99 99 9a 95 42 09 |.....B..|......B.|
|000006f0| 99 99 99 99 99 9a 00 0c | 00 06 00 81 00 02 00 09 |........|........|
|00000700| 40 80 00 00 00 00 00 00 | 95 40 80 00 00 00 00 00 |@.......|.@......|
|00000710| 00 00 0c 00 07 00 82 00 | 02 00 06 41 40 00 00 00 |........|...A@...|
|00000720| 00 00 00 90 94 00 0c 00 | 02 00 0c 00 08 00 82 00 |........|........|
|00000730| 02 00 0c 42 10 00 00 00 | 00 00 00 90 94 00 0c 00 |...B....|........|
|00000740| 02 8e 94 00 0c 00 02 00 | 0e 00 01 00 08 00 00 00 |........|........|
|00000750| 41 00 00 00 02 6d 20 00 | 01 27 53 6f 6c 76 65 20 |A....m .|.'Solve |
|00000760| 74 68 69 73 20 70 72 6f | 62 6c 65 6d 20 62 79 20 |this pro|blem by |
|00000770| 77 72 69 74 69 6e 67 20 | 74 68 65 20 61 62 6f 76 |writing |the abov|
|00000780| 65 20 61 73 20 61 20 73 | 79 73 74 65 6d 20 6f 66 |e as a s|ystem of|
|00000790| 20 65 71 75 61 74 69 6f | 6e 73 00 0f 00 04 00 08 | equatio|ns......|
|000007a0| 00 00 00 05 00 00 00 02 | 6d 20 00 01 27 59 3d 4d |........|m ..'Y=M|
|000007b0| 58 00 10 00 01 00 08 00 | 00 00 43 00 00 00 02 c7 |X.......|..C.....|
|000007c0| 1e 00 04 27 77 68 65 72 | 65 20 59 3d 5b 79 69 5d |...'wher|e Y=[yi]|
|000007d0| 2c 20 4d 3d 20 5b 31 20 | 78 69 20 78 69 5e 32 5d |, M= [1 |xi xi^2]|
|000007e0| 20 61 6e 64 20 58 3d 74 | 72 61 6e 73 70 6f 73 65 | and X=t|ranspose|
|000007f0| 5b 61 20 62 20 63 5d 20 | 28 63 6f 65 66 66 69 63 |[a b c] |(coeffic|
|00000800| 69 65 6e 74 73 29 00 11 | 00 01 00 08 00 00 00 46 |ients)..|.......F|
|00000810| 00 00 00 02 c7 1e 00 04 | 27 46 69 6e 64 20 74 68 |........|'Find th|
|00000820| 65 20 73 6f 6c 75 74 69 | 6f 6e 20 58 20 62 79 20 |e soluti|on X by |
|00000830| 75 73 69 6e 67 20 58 3d | 69 6e 76 65 72 73 65 28 |using X=|inverse(|
|00000840| 74 72 61 6e 73 70 6f 73 | 65 28 4d 29 2a 4d 29 2a |transpos|e(M)*M)*|
|00000850| 74 72 61 6e 73 70 6f 73 | 65 28 4d 29 2a 59 00 14 |transpos|e(M)*Y..|
|00000860| 00 03 00 08 00 00 00 03 | 00 00 00 02 6d 20 00 01 |........|....m ..|
|00000870| 27 58 3a 00 14 00 05 00 | 02 00 00 00 4a 40 80 00 |'X:.....|....J@..|
|00000880| 00 00 00 00 00 90 c7 39 | 88 94 00 15 00 04 8a c7 |.......9|........|
|00000890| 3a 88 c7 3b 7f 94 00 07 | 00 06 92 94 00 0c 00 08 |:..;....|........|
|000008a0| 7e 8e 7f 94 00 07 00 06 | 92 94 00 0c 00 08 7e 89 |~.......|......~.|
|000008b0| 8e c7 3b 7f 94 00 07 00 | 06 92 94 00 0c 00 08 7e |..;.....|.......~|
|000008c0| 8e 7f 94 00 07 00 04 92 | 94 00 0c 00 04 7e 89 00 |........|.....~..|
|000008d0| 14 00 06 00 08 00 00 00 | 20 00 00 00 02 ac bc 00 |........| .......|
|000008e0| 04 27 3c 3d 3d 20 54 68 | 65 20 6d 61 74 72 69 78 |.'<== Th|e matrix|
|000008f0| 20 66 75 6e 63 74 69 6f | 6e 20 69 6e 20 68 65 72 | functio|n in her|
|00000900| 65 00 15 00 02 00 08 00 | 00 00 02 00 00 00 02 6d |e.......|.......m|
|00000910| 20 00 01 27 61 00 15 00 | 04 00 01 00 00 00 09 40 | ..'a...|.......@|
|00000920| 88 72 b0 20 c4 9b 58 95 | 40 88 72 b0 20 c4 9b 58 |.r. ..X.|@.r. ..X|
|00000930| 00 16 00 02 00 08 00 00 | 00 02 00 00 00 02 6d 20 |........|......m |
|00000940| 00 01 27 62 00 16 00 04 | 00 01 00 00 00 09 40 6e |..'b....|......@n|
|00000950| aa 46 cd 62 99 00 95 40 | 6e aa 46 cd 62 99 00 00 |.F.b...@|n.F.b...|
|00000960| 17 00 02 00 08 00 00 00 | 02 00 00 00 02 6d 20 00 |........|.....m .|
|00000970| 01 27 63 00 17 00 04 00 | 01 00 00 00 09 40 0a 3d |.'c.....|.....@.=|
|00000980| 70 a3 d7 09 c8 95 40 0a | 3d 70 a3 d7 09 c8 00 19 |p.....@.|=p......|
|00000990| 00 03 00 08 00 00 00 14 | 00 00 00 02 c2 04 00 04 |........|........|
|000009a0| 27 45 73 74 69 6d 61 74 | 65 20 79 20 76 61 6c 75 |'Estimat|e y valu|
|000009b0| 65 73 3a 00 00 19 00 06 | 00 08 00 00 00 13 00 00 |es:.....|........|
|000009c0| 00 02 6d 20 00 01 27 20 | 20 41 63 74 75 61 6c 20 |..m ..' | Actual |
|000009d0| 79 20 76 61 6c 75 65 73 | 3a 00 1a 00 04 00 82 00 |y values|:.......|
|000009e0| 02 00 24 40 d5 64 ef e8 | 98 22 d1 90 8b 00 15 00 |..$@.d..|."......|
|000009f0| 04 8e 94 00 07 00 06 90 | 8b 00 16 00 04 8e 94 00 |........|........|
|00000a00| 07 00 07 90 8b 00 17 00 | 04 8e 94 00 07 00 08 00 |........|........|
|00000a10| 1a 00 06 00 81 00 02 00 | 09 40 da e1 47 ae 14 7a |........|.@..G..z|
|00000a20| e1 95 40 da e1 47 ae 14 | 7a e1 00 1b 00 04 00 82 |..@..G..|z.......|
|00000a30| 00 02 00 24 41 22 73 45 | ec b0 b6 5e 90 8b 00 15 |...$A"sE|...^....|
|00000a40| 00 04 8e 94 00 08 00 06 | 90 8b 00 16 00 04 8e 94 |........|........|
|00000a50| 00 08 00 07 90 8b 00 17 | 00 04 8e 94 00 08 00 08 |........|........|
|00000a60| 00 1b 00 06 00 81 00 02 | 00 09 41 1c cc cc cc cc |........|..A.....|
|00000a70| cc cd 95 41 1c cc cc cc | cc cc cd 00 1c 00 04 00 |...A....|........|
|00000a80| 82 00 02 00 24 41 6b 7b | c1 f9 90 3c 8d 90 8b 00 |....$Ak{|...<....|
|00000a90| 15 00 04 8e 94 00 09 00 | 06 90 8b 00 16 00 04 8e |........|........|
|00000aa0| 94 00 09 00 07 90 8b 00 | 17 00 04 8e 94 00 09 00 |........|........|
|00000ab0| 08 00 1c 00 06 00 81 00 | 02 00 09 41 73 d7 0a 3d |........|...As..=|
|00000ac0| 70 a3 d7 95 41 73 d7 0a | 3d 70 a3 d7 00 1d 00 04 |p...As..|=p......|
|00000ad0| 00 82 00 02 00 24 41 a2 | e5 f6 0d 75 51 fa 90 8b |.....$A.|...uQ...|
|00000ae0| 00 15 00 04 8e 94 00 0a | 00 06 90 8b 00 16 00 04 |........|........|
|00000af0| 8e 94 00 0a 00 07 90 8b | 00 17 00 04 8e 94 00 0a |........|........|
|00000b00| 00 08 00 1d 00 06 00 81 | 00 02 00 09 41 99 99 99 |........|....A...|
|00000b10| 99 99 99 9a 95 41 99 99 | 99 99 99 99 9a 00 1e 00 |.....A..|........|
|00000b20| 04 00 82 00 02 00 24 41 | d8 b1 e2 28 5f f6 4a 90 |......$A|...(_.J.|
|00000b30| 8b 00 15 00 04 8e 94 00 | 0b 00 06 90 8b 00 16 00 |........|........|
|00000b40| 04 8e 94 00 0b 00 07 90 | 8b 00 17 00 04 8e 94 00 |........|........|
|00000b50| 0b 00 08 00 1e 00 06 00 | 81 00 02 00 09 41 e3 33 |........|.....A.3|
|00000b60| 33 33 33 33 33 95 41 e3 | 33 33 33 33 33 33 00 1f |33333.A.|333333..|
|00000b70| 00 04 00 82 00 02 00 24 | 42 0b 90 d2 a6 c4 05 9c |.......$|B.......|
|00000b80| 90 8b 00 15 00 04 8e 94 | 00 0c 00 06 90 8b 00 16 |........|........|
|00000b90| 00 04 8e 94 00 0c 00 07 | 90 8b 00 17 00 04 8e 94 |........|........|
|00000ba0| 00 0c 00 08 00 1f 00 06 | 00 81 00 02 00 09 42 09 |........|......B.|
|00000bb0| 99 99 99 99 99 9a 95 42 | 09 99 99 99 99 99 9a    |.......B|....... |
+--------+-------------------------+-------------------------+--------+--------+